From 46f9e6dbc28ccdc099f756b7b053c273113f89f0 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 18 Jul 2026 15:30:22 +0000 Subject: [PATCH] Add ARRIVALS.Updated column Resolves problem #45. --- conversion/load_follow_arrival.m4 | 6 ++++-- db/schemas/sokwedb/tables/create/arrivals.m4 | 3 +++ doc/src/epilog.inc.m4 | 2 ++ doc/src/tables/arrivals.m4 | 14 ++++++++++++++ 4 files changed, 23 insertions(+), 2 deletions(-) diff --git a/conversion/load_follow_arrival.m4 b/conversion/load_follow_arrival.m4 index f69dbd4..1ecd569 100644 --- a/conversion/load_follow_arrival.m4 +++ b/conversion/load_follow_arrival.m4 @@ -94,7 +94,8 @@ BEGIN , neststart , nestend , cycle - , datasource) + , datasource + , updated) VALUES ( currval('events_eid_seq') , CASE @@ -118,7 +119,8 @@ BEGIN THEN TRUE END , this_fa.fa_type_of_cycle - , this_fa.fa_data_source); + , this_fa.fa_data_source + , this_fa.fa_update); END LOOP; END; diff --git a/db/schemas/sokwedb/tables/create/arrivals.m4 b/db/schemas/sokwedb/tables/create/arrivals.m4 index dcb7044..4b5a7f9 100644 --- a/db/schemas/sokwedb/tables/create/arrivals.m4 +++ b/db/schemas/sokwedb/tables/create/arrivals.m4 @@ -34,6 +34,9 @@ CREATE TABLE arrivals ( REFERENCES cycle_states ,datasource TEXT NOT NULL REFERENCES arrival_sources + ,updated DATE + CONSTRAINT "ARRIVALS.Updated must not be before sdb_min_follow_date" + CHECK(updated >= 'sdb_min_follow_date') ); eid_primary_key(`ARRIVALS') diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4 index c22a8ef..9c7b467 100644 --- a/doc/src/epilog.inc.m4 +++ b/doc/src/epilog.inc.m4 @@ -144,6 +144,8 @@ sdb_generated_rst()dnl replace:: :ref:`Cycle ` .. |ARRIVALS.DataSource| replace:: :ref:`DataSource ` +.. |ARRIVALS.Updated| + replace:: :ref:`Updated ` .. |ARRIVALS_A| replace:: :ref:`ARRIVALS_A ` diff --git a/doc/src/tables/arrivals.m4 b/doc/src/tables/arrivals.m4 index e78d043..ffe739b 100644 --- a/doc/src/tables/arrivals.m4 +++ b/doc/src/tables/arrivals.m4 @@ -164,3 +164,17 @@ DataSource (Data Source) departure information. |ARRIVALS.DataSource_summary| |notnull| + + +.. _ARRIVALS.Updated: + +Updated +``````` + +.. |ARRIVALS.Updated_summary| replace:: + Date the row was last updated. + +|ARRIVALS.Updated_summary| +This date may not be before ``sdb_min_follow_date``. +This column may be |null| when there is no information on the date +last updated. -- 2.34.1